Business Intelligence for the Programs of the Secretaries of Health, Education and Planning in a Territorial Entity

Territorial entities in Colombia are bound by the law to register and report different instances control information of government programs they administer. However, so much is distributed on various state owned platforms that result processed generated formats. This situation makes comprehensive management territorial data difficult, since, although exists, it isolated, its analysis carried out independently each party responsible for process. The objective this research Implementation a business intelligence model allows integration from Health, Education, Planning ministries Entity. Ralph Kimball's methodology was used, implementing star topology Datamart using MySQL as database manager, an ETL system built with Pentaho tool which extraction, transformation, loading Datamart. cubes, reports Dashboard obtained tools such Power BI, thus possible make correct interpretation resulting information. After applying Business Intelligence, generate adequate information, allowing decision-making application new strategies solve specific problems panels, visualization indicators generation reports.